forum

home / developersection / forums / how to fetch same record from two table in sql server?

Ask Question
Steilla Mitchel

Student

I completed my post-graduation in 2013 in the engineering field. Engineering is the application of science and math to solve problems. Engineers figure out how things work and find practical uses for scientific discoveries. Scientists and inventors often get the credit for innovations that advance the human condition, but it is engineers who are instrumental in making those innovations available to the world. I love pet animals such as dogs, cats, etc.

Follow
Can you answer this question?
Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

18-Nov-2021

Fetch same Record from Two table:

 The INTERSECT Operator is used to find the same record from two database in SQL Server.

Let us create two table Employees and Manager

Employees table:How to fetch same record from two table in SQL Server?

Manager table:How to fetch same record from two table in SQL Server?

Now, the following SQL statement is find the same record from above both table by using INTERSECT Clause,

    How to fetch same record from two table in SQL Server?

Output:

                    How to fetch same record from two table in SQL Server?

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy